GetDataTable

/ Assembly List / LJCDataAccess / DataAccess / GetDataTable

Namespace - LJCDataAccess

Parameters

sql - The Select SQL statement.

tableMapping - The table map collection.

Returns

A reference to the DataTable object.

Syntax

C#
public DataTable GetDataTable(String sql, DataTableMappingCollection tableMapping = null)

Executes a Select statement and retrieves the DataTable object. (E)

Example

C#
// See the DataAccess setup code on the DataAccess class page. // Executes a Select statement and retrieves the DataTable object. private static void GetDataTable(DataAccess dataAccess) { string sql = "select * from TableName"; DataTable dataTable = dataAccess.GetDataTable(sql); if (dataTable != null) { foreach (DataRow dataRow in dataTable.Rows) { for int index = 0; index < dataTable.Columns.Count; index++) { string value = dataRow[index].ToString(); } } } }

// See the DataAccess setup code on the DataAccess class page.

// Executes a Select statement and retrieves the DataTable object.
private static void GetDataTable(DataAccess dataAccess)
{
    string sql = "select * from TableName";

    DataTable dataTable = dataAccess.GetDataTable(sql);
    if (dataTable != null)
    {
        foreach (DataRow dataRow in dataTable.Rows)
        {
            for int index = 0; index < dataTable.Columns.Count; index++)
            {
                string value = dataRow[index].ToString();
            }
        }
    }
}